Interview Questions

1. Which of the the following steps should be carried out using data types in SSIS for efficient results ?

Options:

a. Make data types as wide as possible so you will allocate more memory for your transformation

b. Do not perform excessive casting of data types

c. Do not watch precision issues when using the money, float, and decimal types

d. None of the mentioned

Reveal Answer

2. The column in a table is set to read only then can we create a new column using derived column?

Options:

a. True

b. False

Reveal Answer

3. Merge join works as ?

Options:

a. Right outer join

b. Left right full

c. Inner left full

Reveal Answer

4. In the event of an Execute SQL task failing, changes made by all of the Execute SQL tasks is rolled back. To do that which of the following is the value that must be set for the Transaction Option property of the package?

Options:

a. Supported

b. Not Required

c. Required

d. Not Supported

Reveal Answer

5. ____________ is a set of graphical tools that allows you to transfer data between disparate sources into one or more destinations.

Options:

a. Data Transfer Services

b. Data Transformation Services

c. Data Disperse Services

d. Data transform Services

Reveal Answer

6. Define Lookup transformation?

Options:

a. Used as reference table.

b. Used as master table

c. Used as fact table

d. None

Reveal Answer

7. Define synchronous transformations?

Options:

a. Input rows count and Output rows count are same

b. Input rows count and Output rows count are not same

c. None

d. Input rows count and Output rows count are different

Reveal Answer

8. How to rename file using SSIS tasks?

Options:

a. Using lookup

b. Using Data flow

c. Using File system task

d. None

Reveal Answer

9. What does mean by data auditing?

Options:

a. To maintain data load statistics in ETL process

b. To know the errors

c. To know the Primary keys

d. None

Reveal Answer

10. How many container tasks available in SSIS?

Options:

a. One

b. Two

c. Three

d. Four

Reveal Answer

11. What is the difference between UNION and UNION ALL?

Options:

a. Union selects only unique row (data) from all queries and Union all selects all rows from all queries

b. Union selects row (data) from all queries and Union all selects all rows from all queries

c. Union selects only unique row (data) from all queries and Union all selects rows from all queries

d. Union selects row (data) from all queries and Union all selects rows from all queries

Reveal Answer

12. Define Row Number function?

Options:

a. To generate sequence number

b. To generate sequence number based on order by column

c. To generate number

d. None

Reveal Answer

13. What is BCP?

Options:

a. Bulk copy program

b. Business continuity program

c. A and B

d. None

Reveal Answer

14. The Lookup transformation requires the use of client side cache?

Options:

a. True

b. False

Reveal Answer

15. Which of the following Data Flow Transformation can send data down multiple success paths?

Options:

a. Multicast

b. Conditional Split

c. Lookup

d. Slowly Changing Dimension

e. All of the above

Reveal Answer

Interview Questions and Answer

1. Which of the the following steps should be carried out using data types in SSIS for efficient results ?

2. The column in a table is set to read only then can we create a new column using derived column?

3. Merge join works as ?

4. In the event of an Execute SQL task failing, changes made by all of the Execute SQL tasks is rolled back. To do that which of the following is the value that must be set for the Transaction Option property of the package?

5. ____________ is a set of graphical tools that allows you to transfer data between disparate sources into one or more destinations.

6. Define Lookup transformation?

7. Define synchronous transformations?

8. How to rename file using SSIS tasks?

9. What does mean by data auditing?

10. How many container tasks available in SSIS?

11. What is the difference between UNION and UNION ALL?

12. Define Row Number function?

13. What is BCP?

14. The Lookup transformation requires the use of client side cache?

15. Which of the following Data Flow Transformation can send data down multiple success paths?

Packages

Trending Certification Courses:

Microsoft Mock Exams:

Other links

About

Resources